Re: input data libreoffice calc to postgreSQL Databases - Mailing list pgsql-novice

From Daniel Staal
Subject Re: input data libreoffice calc to postgreSQL Databases
Date
Msg-id 36AEF870761900076154E5EE@[192.168.1.50]
Whole thread Raw
In response to input data libreoffice calc to postgreSQL Databases  (Morovikov Vladimir <integr1@yandex.ru>)
List pgsql-novice
--As of December 12, 2014 10:15:54 AM +0300, Morovikov Vladimir is alleged
to have said:

>
> Dear Colleagues!
> How to enter data libreoffice calc in postgresql( Linux)?
> Best regards,Vladimir.

--As for the rest, it is mine.

There's a lot of variables based on details you haven't mentioned, but in
general the simplest way is probably to export the spreadsheet into a CSV
file and then import it into an appropriate table, using the COPY command.

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author.  Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes.  This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------


pgsql-novice by date:

Previous
From: Morovikov Vladimir
Date:
Subject: input data libreoffice calc to postgreSQL Databases
Next
From: Scott Robertson
Date:
Subject: work copying over to closed servers and databases